home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_FACULTY.ACCDT_1043 / template / database / objects / queryFacultyExtendedFlipAddress.txt < prev    next >
Text File  |  2006-11-12  |  4KB  |  105 lines
  1. ∩╗┐Operation =1
  2. Option =0
  3. Begin InputTables
  4.     Name ="Faculty"
  5. End
  6. Begin OutputColumns
  7.     Alias ="File As"
  8.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  9.     Alias ="Contact Name"
  10.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  11.     Expression ="Faculty.*"
  12. End
  13. Begin OrderBy
  14.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  15.     Flag =0
  16.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  17.     Flag =0
  18. End
  19. dbBoolean "ReturnsRecords" ="-1"
  20. dbInteger "ODBCTimeout" ="60"
  21. dbByte "RecordsetType" ="0"
  22. dbBoolean "OrderByOn" ="0"
  23. dbByte "Orientation" ="0"
  24. dbByte "DefaultView" ="2"
  25. dbBoolean "FilterOnLoad" ="0"
  26. dbBoolean "OrderByOnLoad" ="-1"
  27. dbBoolean "TotalsRow" ="0"
  28. dbLongBinary "DOL" = Begin
  29.     0x0acc0e5500000000ab6397e9fa59e6489c9a9ef875cb329a000000005253566c ,
  30.     0x570ae340010000004029283446006100630075006c0074007900000000000000 ,
  31.     0xa07813be085ff249aae6fd9e2988b7cd070000008bb1892290b04a4d9b904c0f ,
  32.     0x2871c057460069006c00650020004100730000000000000003f5339da9076d4a ,
  33.     0xae1e33c02b04686a070000008bb1892290b04a4d9b904c0f2871c05743006f00 ,
  34.     0x6e00740061006300740020004e0061006d00650000000000000019c853d3c1ab ,
  35.     0x0249a2ca235a4cff9b3f07000000ab6397e9fa59e6489c9a9ef875cb329a4c00 ,
  36.     0x61007300740020004e0061006d006500000000000000d59333a5d01a7340b33c ,
  37.     0xc1b4956b48ee07000000ab6397e9fa59e6489c9a9ef875cb329a460069007200 ,
  38.     0x7300740020004e0061006d00650000000000000052304034cee838409eddf5a6 ,
  39.     0xcf79599a07000000ab6397e9fa59e6489c9a9ef875cb329a43006f006d007000 ,
  40.     0x61006e007900000000000000000000000000000000000000000000000c000000 ,
  41.     0x040000000000000000000000000000000000 ,
  42.     0x0acc0e5500000000ab6397e9fa59e6489c9a9ef875cb329a000000005253566c ,
  43.     0x570ae340010000004029283446006100630075006c0074007900000000000000 ,
  44.     0xcc66e869a2a01249adbd1c655258d7a507000000cf3b792a5a28ac4bbe158e6a ,
  45.     0x792d71a8460069006c006500200041007300000000000000a3e0cac1326b5f4f ,
  46.     0x803959eacbca3f9807000000cf3b792a5a28ac4bbe158e6a792d71a843006f00 ,
  47.     0x6e00740061006300740020004e0061006d00650000000000000019c853d3c1ab ,
  48.     0x0249a2ca235a4cff9b3f07000000ab6397e9fa59e6489c9a9ef875cb329a4c00 ,
  49.     0x61007300740020004e0061006d006500000000000000d59333a5d01a7340b33c ,
  50.     0xc1b4956b48ee07000000ab6397e9fa59e6489c9a9ef875cb329a460069007200 ,
  51.     0x7300740020004e0061006d00650000000000000052304034cee838409eddf5a6 ,
  52.     0xcf79599a07000000ab6397e9fa59e6489c9a9ef875cb329a43006f006d007000 ,
  53.     0x61006e007900000000000000000000000000000000000000000000000c000000 ,
  54.     0x040000000000000000000000000000000000
  55. End
  56. dbBinary "GUID" = Begin
  57.     0x8bb1892290b04a4d9b904c0f2871c057
  58. End
  59. Begin
  60.     Begin
  61.         dbText "Name" ="Contact Name"
  62.         dbInteger "ColumnWidth" ="1695"
  63.         dbInteger "ColumnOrder" ="1"
  64.         dbBoolean "ColumnHidden" ="0"
  65.         dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
  66.         dbLong "AggregateType" ="-1"
  67.         dbBinary "GUID" = Begin
  68.             0x03f5339da9076d4aae1e33c02b04686a
  69.         End
  70.     End
  71.     Begin
  72.         dbText "Name" ="File As"
  73.         dbInteger "ColumnWidth" ="1695"
  74.         dbInteger "ColumnOrder" ="2"
  75.         dbBoolean "ColumnHidden" ="0"
  76.         dbLong "AggregateType" ="-1"
  77.         dbBinary "GUID" = Begin
  78.             0xa07813be085ff249aae6fd9e2988b7cd
  79.         End
  80.     End
  81. End
  82. Begin
  83.     State =0
  84.     Left =0
  85.     Top =0
  86.     Right =799
  87.     Bottom =520
  88.     Left =-1
  89.     Top =-1
  90.     Right =784
  91.     Bottom =252
  92.     Left =0
  93.     Top =0
  94.     ColumnsShown =539
  95.     Begin
  96.         Left =48
  97.         Top =12
  98.         Right =192
  99.         Bottom =156
  100.         Top =0
  101.         Name ="Faculty"
  102.         Name =""
  103.     End
  104. End
  105.